mission1

Tables (5)

Categories (카테고리)

  • id (Key) — bigint — Primary key — NOT NULL
  • p_id (Key2) — bigint — Foreign key → Categories.id — NOT NULL
  • category_name (Field) — varchar(200)
  • category_order (Field2) — integer
  • created_date (Field3) — timestamp
  • created_by (Field4) — varchar(20)
  • last_modified_date (Field5) — timestamp
  • last_modified_by (Field6) — varchar(20)

Contents (Untitled)

  • content_id (Key) — bigint — Primary key — NOT NULL
  • category_id (Key2) — bigint — Foreign key → Categories.id — NOT NULL
  • content_title (Field) — varchar(200)
  • content_description (Field2) — varchar(1000)
  • content_path (Field3) — varchar(1000)
  • created_date (Field4) — timestamp
  • created_by (Field5) — varchar(20)
  • last_modified_date (Field6) — timestamp
  • last_modified_by (Field7) — varchar(20)

Contents_Tags (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • tag_id (Key2) — bigint — Foreign key → Tags.tag_id — NOT NULL
  • content_id (Key3) — bigint — Foreign key → Contents.content_id — NOT NULL

Tags (태그)

  • tag_id (Key) — bigint — Primary key — NOT NULL
  • tag_name (Field) — varchar(100)
  • created_date (Field2) — timestamp
  • created_by (Field3) — varchar(20)
  • last_modified_date (Field4) — timestamp
  • last_modified_by (Field5) — varchar(20)

Users (유저)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Field) — varchar(20)
  • password (Field2) — varchar(100)
  • user_name (Field3) — varchar(50)
  • email (Field4) — varchar(100)
  • phone (Field5) — varchar(100)
  • role (Field6) — varchar(100)
  • created_date (Field7) — timestamp
  • created_by (Field8) — varchar(20)
  • last_modified_date (Field9) — timestamp
  • last_modified_by (Field10) — varchar(20)