gobookrun

Tables (5)

book

  • code — varchar2(30) — Primary key — NOT NULL
  • title — varchar2(255)
  • author — varchar2(255)
  • page — int
  • cover — varchar2(1000)

member

  • email — varchar2(50) — Primary key — NOT NULL
  • pw — warchar2(255)
  • nickname — varchar2(20)
  • auth — varchar2(1)
  • delete_yn — varchar2(1)

record

  • code — varchar2(30) — Primary key — NOT NULL
  • title — varchar2(255)
  • author — varchar2(255)
  • cover — varchar2(1000)
  • startdate — date
  • enddate — date
  • status — varchar2(1)
  • display — varchar2(1)
  • nowpage — int
  • totalpage — int
  • email — varchar2(50)

role

  • code — varchar2(1) — Primary key

user_role

  • email — varchar2(50) — Foreign key → member.email — NOT NULL
  • code — varchar2(1) — Foreign key → role.code