efwkl
Tables (6)
block_category
- category — varchar(45) — Primary key — NOT NULL
comment
- no — bigint — Primary key — NOT NULL
- user_id — varchar(45) — Foreign key → user.id — NOT NULL
- movie_no — bigint — NOT NULL
- score — int
- content — text — NOT NULL
- create_date — datetime
- update_date — datetime
report_status
- status — varchar(45) — Primary key — NOT NULL
user
- id — varchar(45) — Primary key — NOT NULL
- user_block_state — bigint — Foreign key → user_block_status.no — NOT NULL
- pw — varchar(60) — NOT NULL
- email — varchar(200) — NOT NULL
- name — varchar(20) — NOT NULL
- birth — date — NOT NULL
- regist_date — datetime — NOT NULL
- user_dormant_state — varchar(10)
- visit_date — datetime — NOT NULL
user_block_status
- no — bigint — Primary key — NOT NULL
- category — varchar(45) — Foreign key → block_category.category — NOT NULL
- id — varchar(45) — Foreign key → user.id — NOT NULL
- msg — text
- start_date — datetime
- end_date — datetime
user_report
- no — bigint — Primary key — NOT NULL
- user_id — varchar(45) — Foreign key → user.id — NOT NULL
- status — varchar(45) — Foreign key → report_status.status — NOT NULL
- reg_date — datetime — NOT NULL
- reported_type — int — NOT NULL
- memo — text