LeejoeDdo
Tables (8)
Board
- board_id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.user_id
- title (Field) — varchar(100) — NOT NULL
- content (Field2) — TEXT — NOT NULL
- created_at (Field3) — DATETIME — NOT NULL
- updated_at (Field4) — DATETIME
Code_post
- code_id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.user_id
- title (Field) — varchar(50)
- content (Field2) — TEXT
- created_at (Field3) — DATETIME — NOT NULL
- uopdated_at (Field4) — DATETIME
- file_url (Field5) — varchar(100)
Comment
- comment_id (Key) — INT — Primary key — NOT NULL
- idea_id (Key2) — INT — Foreign key → Idea_post.idea_id — NOT NULL
- user_id (Key22) — INT — Foreign key → Idea_post.user_id
- author_id (Key3) — INT — Foreign key → User.user_id — user_id 참조하는 누가 작성햇는지
- content (Field) — TEXT — NOT NULL
- created_at (Field2) — DATETIME — NOT NULL
- updated_at (Field3) — DATETIME
Event
- event_id (Key) — INT — Primary key — NOT NULL
- title (Field) — varchar(50) — NOT NULL
- description (Field2) — TEXT — NOT NULL — 행사설명
- start_date (Field3) — DATETIME — NOT NULL
- end_date (Field4) — DATETIME — NOT NULL
- created_at (Field5) — DATETIME — NOT NULL
- updated_at (Field6) — DATETIME
Event_apply
- apply_id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.user_id
- event_id (Key3) — INT — Foreign key → Event.event_id — NOT NULL
Idea_post
- idea_id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.user_id
- title (Field) — varchar(50) — NOT NULL
- content (Field2) — TEXT — NOT NULL
- created_at (Field3) — DATETIME — NOT NULL
- updated_at (Field4) — DATETIME
Model_post
- Model_id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → User.user_id
- title (Field) — varchar(50) — NOT NULL
- content (Field2) — TEXT — NOT NULL
- created_at (Field3) — DATETIME — NOT NULL
- updated_at (Field4) — DATETIME — NOT NULL
- file_url (Field5) — varchar(100)
User
- user_id (Key) — INT — Primary key
- username (Field) — varchar(50) — NOT NULL
- password (Field2) — varchar(50) — NOT NULL
- email (Field3) — varchar(60) — NOT NULL
- role (Field4) — enum — NOT NULL — admin, memer
- created_at (Field5) — datetime — NOT NULL
- updated_at (Field6) — datetime