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