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)