【正文】 ister_FK/drop index belong_FK/drop index consume_FK/drop table BANLI cascade constraints/drop table account cascade constraints/drop table bank_card cascade constraints/drop table pay cascade constraints/drop table phone_cost cascade constraints/drop table register cascade constraints/drop table staff cascade constraints/drop table user cascade constraints/drop table 手機(jī) cascade constraints/drop table 業(yè)務(wù) cascade constraints//*==============================================================*//* Table: BANLI *//*==============================================================*/create table BANLI ( YEWU_no CHAR(6) not null, 手機(jī)號(hào)碼 CHAR(10) not null, BANLI_time DATE, constraint PK_BANLI primary key (YEWU_no, 手機(jī)號(hào)碼))//*==============================================================*//* Index: BANLI_FK *//*==============================================================*/create index BANLI_FK on BANLI ( YEWU_no ASC)//*==============================================================*//* Index: BANLI2_FK *//*==============================================================*/create index BANLI2_FK on BANLI ( 手機(jī)號(hào)碼 ASC)//*==============================================================*//* Table: account *//*==============================================================*/create table account ( account_no CHAR(10) not null, consume_month CHAR(4), YEWU_fee NUMBER(8), constraint PK_ACCOUNT primary key (account_no))//*==============================================================*//* Table: bank_card *//*==============================================================*/create table bank_card ( card_no CHAR(18) not null, ID_no CHAR(18) not null, card_balance NUMBER(8), constraint PK_BANK_CARD primary key (card_no))//*==============================================================*//* Index: use_FK *//*==============================================================*/create index use_FK on bank_card ( ID_no ASC)//*==============================================================*//* Table: pay *//*==============================================================*/create table pay ( card_no CHAR(18) not null, fee_no CHAR(10) not null, pay_sum NUMBER(8) not null, pay_time DATE not null, constraint PK_PAY primary key (card_no, fee_no))//*==============================================================*//* Index: pay_FK *//*==============================================================*/create index pay_FK on pay ( card_no ASC)//*==============================================================*//* Index: pay2_FK *//*==============================================================*/create index pay2_FK on pay ( fee_no ASC)//*==============================================================*//* Table: phone_cost *//*==============================================================*/create table phone_cost ( fee_no CHAR(10) not null, phone_no CHAR(12), fee_balance NUMBER(8), constraint PK_PHONE_COST primary key (fee_no))//*==============================================================*//* Table: register *//*==============================================================*/create table register ( staff_id CHAR(10) not null, ID_no CHAR(18) not null, register_time DATE, phone_no CHAR(12), constraint PK_REGISTER primary key (staff_id, ID_no))//*============================================================