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)