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