com.medsys.doc.patient.entity.MedHisFinOprRegisterDO 门诊患者挂号表
-- Create table
create table FIN_OPR_REGISTER
(
  clinic_code          VARCHAR2(14) not null,
  trans_type           VARCHAR2(1) not null,
  card_no              VARCHAR2(10) not null,
  reg_date             DATE not null,
  noon_code            VARCHAR2(1),
  name                 VARCHAR2(60),
  idenno               VARCHAR2(18),
  sex_code             VARCHAR2(1),
  birthday             DATE,
  rela_phone           VARCHAR2(20),
  address              VARCHAR2(200),
  card_type            VARCHAR2(3),
  paykind_code         VARCHAR2(2),
  paykind_name         VARCHAR2(14),
  pact_code            VARCHAR2(10),
  pact_name            VARCHAR2(50),
  mcard_no             VARCHAR2(50),
  reglevl_code         VARCHAR2(3),
  reglevl_name         VARCHAR2(20),
  dept_code            VARCHAR2(4),
  dept_name            VARCHAR2(50),
  schema_no            VARCHAR2(12),
  order_no             NUMBER(5),
  seeno                NUMBER(5),
  begin_time           DATE,
  end_time             DATE,
  doct_code            VARCHAR2(6),
  doct_name            VARCHAR2(14),
  ynregchrg            VARCHAR2(1),
  invoice_no           VARCHAR2(12),
  recipe_no            VARCHAR2(10),
  ynbook               VARCHAR2(1),
  ynfr                 VARCHAR2(1),
  append_flag          VARCHAR2(1),
  reg_fee              NUMBER(6,2) default 0,
  chck_fee             NUMBER(6,2) default 0,
  diag_fee             NUMBER(6,2) default 0,
  oth_fee              NUMBER(6,2),
  own_cost             NUMBER(6,2),
  pub_cost             NUMBER(6,2),
  pay_cost             NUMBER(6,2),
  valid_flag           VARCHAR2(1),
  oper_code            VARCHAR2(6),
  oper_date            DATE,
  cancel_opcd          VARCHAR2(6),
  cancel_date          DATE,
  medical_type         VARCHAR2(3),
  icd_code             VARCHAR2(10),
  exam_code            VARCHAR2(6),
  exam_date            DATE,
  check_flag           VARCHAR2(1),
  check_opcd           VARCHAR2(6),
  check_date           DATE,
  balance_flag         VARCHAR2(1) default '0',
  balance_no           VARCHAR2(10),
  balance_opcd         VARCHAR2(6),
  balance_date         DATE,
  ynsee                VARCHAR2(1),
  see_date             DATE,
  triage_flag          VARCHAR2(1) default '0',
  triage_opcd          VARCHAR2(6),
  triage_date          DATE,
  print_invoicecnt     NUMBER(2) default 0,
  see_dpcd             VARCHAR2(4),
  see_docd             VARCHAR2(6),
  in_source            VARCHAR2(4),
  is_sendinhoscase     VARCHAR2(1),
  is_encryptname       VARCHAR2(1) default 0,
  normalname           VARCHAR2(50),
  in_date              DATE,
  out_date             DATE,
  zg                   VARCHAR2(2),
  in_state             VARCHAR2(1) default 'N',
  eco_cost             NUMBER(10,2),
  is_account           VARCHAR2(1) default '0',
  is_emergency         VARCHAR2(1),
  mark1                VARCHAR2(20),
  receipt_doct_code    VARCHAR2(6),
  receipt_doct_date    DATE,
  receipt_flag         VARCHAR2(1) default '0',
  account_no           VARCHAR2(10),
  emr_regid            NUMBER(16),
  db_sp_state          VARCHAR2(2) default '0',
  db_oper_code         VARCHAR2(6),
  db_sp_date           DATE,
  book_code            VARCHAR2(50),
  cancel_book_code     VARCHAR2(50),
  print_oper           VARCHAR2(10),
  print_date           DATE,
  jmjkk_invoice        VARCHAR2(100),
  bank_invoice_seq     VARCHAR2(100),
  source               VARCHAR2(5),
  paymode              VARCHAR2(50),
  ref_man              VARCHAR2(6),
  bak_net_serialnumber VARCHAR2(50),
  bak_net_date         DATE,
  invalid_invoice_no   VARCHAR2(500),
  is_basic_living      VARCHAR2(1) default 0
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 512M
    next 8K
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table FIN_OPR_REGISTER
  is '挂号主表';
-- Add comments to the columns 
comment on column FIN_OPR_REGISTER.clinic_code
  is '门诊号/发票号';
comment on column FIN_OPR_REGISTER.trans_type
  is '交易类型,1正交易，2反交易';
comment on column FIN_OPR_REGISTER.card_no
  is '就诊卡号';
comment on column FIN_OPR_REGISTER.reg_date
  is '挂号日期';
comment on column FIN_OPR_REGISTER.noon_code
  is '午别';
comment on column FIN_OPR_REGISTER.name
  is '姓名';
comment on column FIN_OPR_REGISTER.idenno
  is '身份证号';
comment on column FIN_OPR_REGISTER.sex_code
  is '性别';
comment on column FIN_OPR_REGISTER.birthday
  is '出生日';
comment on column FIN_OPR_REGISTER.rela_phone
  is '联系电话';
comment on column FIN_OPR_REGISTER.address
  is '地址';
comment on column FIN_OPR_REGISTER.card_type
  is '证件类型';
comment on column FIN_OPR_REGISTER.paykind_code
  is '结算类别号';
comment on column FIN_OPR_REGISTER.paykind_name
  is '结算类别名称';
comment on column FIN_OPR_REGISTER.pact_code
  is '合同号';
comment on column FIN_OPR_REGISTER.pact_name
  is '合同单位名称';
comment on column FIN_OPR_REGISTER.mcard_no
  is '医疗证号';
comment on column FIN_OPR_REGISTER.reglevl_code
  is '挂号级别';
comment on column FIN_OPR_REGISTER.reglevl_name
  is '挂号级别名称';
comment on column FIN_OPR_REGISTER.dept_code
  is '科室号';
comment on column FIN_OPR_REGISTER.dept_name
  is '科室名称';
comment on column FIN_OPR_REGISTER.schema_no
  is '排班序号';
comment on column FIN_OPR_REGISTER.order_no
  is '每日顺序号';
comment on column FIN_OPR_REGISTER.seeno
  is '看诊序号';
comment on column FIN_OPR_REGISTER.begin_time
  is '看诊开始时间';
comment on column FIN_OPR_REGISTER.end_time
  is '看诊结束时间';
comment on column FIN_OPR_REGISTER.doct_code
  is '医师代号';
comment on column FIN_OPR_REGISTER.doct_name
  is '医师姓名';
comment on column FIN_OPR_REGISTER.ynregchrg
  is '挂号收费标志 1是/0否';
comment on column FIN_OPR_REGISTER.invoice_no
  is '发票号';
comment on column FIN_OPR_REGISTER.recipe_no
  is '处方号';
comment on column FIN_OPR_REGISTER.ynbook
  is '0现场挂号/1预约挂号/2特诊挂号';
comment on column FIN_OPR_REGISTER.ynfr
  is '1初诊/0复诊';
comment on column FIN_OPR_REGISTER.append_flag
  is '1加号/0正常';
comment on column FIN_OPR_REGISTER.reg_fee
  is '挂号费';
comment on column FIN_OPR_REGISTER.chck_fee
  is '检查费';
comment on column FIN_OPR_REGISTER.diag_fee
  is '诊察费';
comment on column FIN_OPR_REGISTER.oth_fee
  is '附加费';
comment on column FIN_OPR_REGISTER.own_cost
  is '自费金额';
comment on column FIN_OPR_REGISTER.pub_cost
  is '报销金额';
comment on column FIN_OPR_REGISTER.pay_cost
  is '自付金额';
comment on column FIN_OPR_REGISTER.valid_flag
  is '0退费,1有效,2作废';
comment on column FIN_OPR_REGISTER.oper_code
  is '操作员代码';
comment on column FIN_OPR_REGISTER.oper_date
  is '操作时间';
comment on column FIN_OPR_REGISTER.cancel_opcd
  is '作废人';
comment on column FIN_OPR_REGISTER.cancel_date
  is '作废时间';
comment on column FIN_OPR_REGISTER.medical_type
  is '医疗类别';
comment on column FIN_OPR_REGISTER.icd_code
  is '疾病代码';
comment on column FIN_OPR_REGISTER.exam_code
  is '审批人';
comment on column FIN_OPR_REGISTER.exam_date
  is '审批时间';
comment on column FIN_OPR_REGISTER.check_flag
  is '0未核查/1已核查';
comment on column FIN_OPR_REGISTER.check_opcd
  is '核查人';
comment on column FIN_OPR_REGISTER.check_date
  is '核查时间';
comment on column FIN_OPR_REGISTER.balance_flag
  is '1已日结/0未日结';
comment on column FIN_OPR_REGISTER.balance_no
  is '日结标识号';
comment on column FIN_OPR_REGISTER.balance_opcd
  is '日结人';
comment on column FIN_OPR_REGISTER.balance_date
  is '日结时间';
comment on column FIN_OPR_REGISTER.ynsee
  is '是否看诊 1是/0否';
comment on column FIN_OPR_REGISTER.see_date
  is '看诊日期';
comment on column FIN_OPR_REGISTER.triage_flag
  is '分诊标志,0未分/1已分';
comment on column FIN_OPR_REGISTER.triage_opcd
  is '分诊护士代码';
comment on column FIN_OPR_REGISTER.triage_date
  is '分诊时间';
comment on column FIN_OPR_REGISTER.print_invoicecnt
  is '打印发票数量';
comment on column FIN_OPR_REGISTER.see_dpcd
  is '看诊科室代码';
comment on column FIN_OPR_REGISTER.see_docd
  is '看诊医生代码';
comment on column FIN_OPR_REGISTER.in_source
  is '患者来源';
comment on column FIN_OPR_REGISTER.is_sendinhoscase
  is '1：需要提取病案0：不需要提取病案';
comment on column FIN_OPR_REGISTER.is_encryptname
  is '是否加密姓名';
comment on column FIN_OPR_REGISTER.normalname
  is '密文';
comment on column FIN_OPR_REGISTER.in_date
  is '开始留观日期';
comment on column FIN_OPR_REGISTER.out_date
  is '留观结束日期';
comment on column FIN_OPR_REGISTER.zg
  is '转归代号';
comment on column FIN_OPR_REGISTER.in_state
  is 'N 正常挂号 R 留观登记 I 正在留观 P 出观登记 B 留观出院完成 E 留观转住院登记 C 留观转住院完成';
comment on column FIN_OPR_REGISTER.eco_cost
  is '优惠金额';
comment on column FIN_OPR_REGISTER.is_account
  is '账户流程标识1 账户挂号 0普通';
comment on column FIN_OPR_REGISTER.is_emergency
  is '是否急诊号';
comment on column FIN_OPR_REGISTER.mark1
  is '扩展字段1';
comment on column FIN_OPR_REGISTER.receipt_doct_code
  is '接诊医生';
comment on column FIN_OPR_REGISTER.receipt_doct_date
  is '接诊时间';
comment on column FIN_OPR_REGISTER.receipt_flag
  is '接诊状态';
comment on column FIN_OPR_REGISTER.account_no
  is '门诊一卡通账号';
comment on column FIN_OPR_REGISTER.emr_regid
  is 'EMR挂号流水号 SEQ_FIN_REGID';
comment on column FIN_OPR_REGISTER.db_sp_state
  is '低保审批状态';
comment on column FIN_OPR_REGISTER.db_oper_code
  is '低保审批人';
comment on column FIN_OPR_REGISTER.db_sp_date
  is '低保审批时间';
comment on column FIN_OPR_REGISTER.book_code
  is '订单号 OrderId';
comment on column FIN_OPR_REGISTER.print_oper
  is '居民健康卡打印发票号';
comment on column FIN_OPR_REGISTER.jmjkk_invoice
  is '居民健康卡挂号发票号';
comment on column FIN_OPR_REGISTER.bank_invoice_seq
  is '居民健康卡银行交易号';
comment on column FIN_OPR_REGISTER.source
  is '数据来源';
comment on column FIN_OPR_REGISTER.paymode
  is '支付类型id PaymentWay';
comment on column FIN_OPR_REGISTER.bak_net_serialnumber
  is '第三方交易流水号 TradeSerialNumber';
comment on column FIN_OPR_REGISTER.is_basic_living
  is '低保打折（0：否，1：是）';
-- Create/Recreate indexes 
create index IND_REGISTER2 on FIN_OPR_REGISTER (OPER_DATE, OPER_CODE)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 37M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index IND_REGISTER3 on FIN_OPR_REGISTER (CARD_NO, IN_STATE, REG_DATE)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 51M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index IND_REGISTER4 on FIN_OPR_REGISTER (CANCEL_DATE, CANCEL_OPCD)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 36M
    next 1M
    minextents 1
    maxextents unlimited
  );
create index IND_REGISTER5 on FIN_OPR_REGISTER (REG_DATE, DEPT_CODE)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 39M
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table FIN_OPR_REGISTER
  add constraint PK_REGISTER primary key (CLINIC_CODE, TRANS_TYPE)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 34M
    next 1M
    minextents 1
    maxextents unlimited
  );