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