dam

Tables (5)

Board (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — varchar
  • url (Field2) — varchar
  • board_type (Field3) — varchar
  • admin_id (유저 ID) — BIGINT — Foreign key → User.id — NOT NULL

Comment (CopyOfUntitled2)

  • id (Key2) — BIGINT — Primary key — NOT NULL
  • content (Field2) — varchar
  • created_date (Field3) — DATETIME
  • modified_date (Field4) — DATETIME
  • deleted_date (Field5) — DATETIME
  • group (Field) — BIGINT
  • level (Field6) — BIGINT
  • like (Field7) — BIGINT
  • dislike (Field8) — BIGINT
  • user_id (유저 ID) — BIGINT — Foreign key → User.id — NOT NULL
  • post_id (Key22) — BIGINT — Foreign key → Post.id — NOT NULL

Post (Untitled2)

  • id (Key2) — BIGINT — Primary key — NOT NULL
  • subject (Field) — varchar
  • content (Field2) — varchar
  • created_date (Field3) — DATETIME
  • modified_date (Field4) — DATETIME
  • deleted_date (Field5) — DATETIME
  • user_id (유저 ID) — BIGINT — Foreign key → User.id — NOT NULL
  • board_id (Key) — BIGINT — Foreign key → Board.id — NOT NULL
  • like (Field6) — BIGINT
  • dislike (Field7) — BIGINT
  • like_ratio (Field8) — Double
  • access (Field9) — Boolean

User (유저)

  • id (유저 ID) — BIGINT — Primary key — NOT NULL
  • user_email (Field) — varchar
  • password (Field2) — varchar
  • nickname (Field3) — varchar
  • created_date (Field4) — DATETIME
  • modified_date (Field5) — DATETIME
  • removed_date (Field8) — DATETIME
  • role (Field7) — varchar
  • block_day (Field6) — INT

like (Untitled3)

  • ip_address (Key) — varchar — Primary key — NOT NULL
  • user_id (유저 ID) — BIGINT — Foreign key → User.id — NOT NULL
  • post_id (Key2) — BIGINT — Foreign key → Post.id — NOT NULL
  • comment_id (Key22) — BIGINT — Foreign key → Comment.id — NOT NULL
  • like_or_dislike (Field) — Boolean