pilot
Tables (4)
GOOD (Untitled4)
- lno (Field) — bigint — Primary key
- user_id (Field4) — bigint — Foreign key → USER.user_id
- post_id (Field5) — bigint — Foreign key → POST.post_id
- user_id (Field15) — bigint — Foreign key → POST.user_id
- post_id (Field2) — bigint
- user_id (Field3) — bigint
POST (Untitled2)
- post_id (Field) — bigint — Primary key
- user_id (Field15) — bigint — Foreign key → USER.user_id
- content (Field2) — varchar(1500)
- nickname (Field3) — varchar(16)
- title (Field4) — varchar(40)
- image_path (Field5) — varchar(255)
- music_path (Field6) — varchar(255)
- update_state (Field7) — bit(1)
- thumnail_path (Field8) — varchar(255)
- view_count (Field9) — bigint
- reply_count (Field10) — int
- update_state (Field11) — bit(1)
- create_date (Field13) — datetime(6)
- modified_date (Field14) — datetime(6)
REPLY (Untitled3)
- reply_id (Field) — bigint — Primary key
- post_id (Field12) — bigint — Foreign key → POST.post_id
- user_id (Field15) — bigint — Foreign key → POST.user_id
- user_id (Field8) — bigint — Foreign key → USER.user_id
- content (Field2) — varchar(750)
- image_path (Field3) — varchar(255)
- nested_reply_count (Field4) — int
- nickname (Field5) — varchar(16)
- parent (Field6) — bigint
- state (Field7) — bit(1)
- create_date (Field10) — datetime(6)
- modified_date (Field11) — datetime(6)
USER (Untitled)
- user_id (Field) — bigint — Primary key
- nickname (Field2) — varchar(16)
- email (Field3) — varchar(320)
- password (Field4) — varchar(60)
- email_status (Field5) — bit(1)
- change_ticket (Field6) — bit(1)
- create_date (Field7) — datetime(6)
- modified_date (Field8) — datetime(6)