helper
Tables (3)
article
- id (Field) — praimary — Primary key
- user_id (Key) — not null — Foreign key → user.id — NOT NULL
- article_list_id (Key2) — fk(on update cascade on delete set null) — Foreign key → article_list.id — NOT NULL
- title (Field2) — not null
- content (Field3) — not null
- create_date (Field4) — not null
- update_date (Field5) — null
- hits (Field6) — not null
article_list
- id (Key) — praimary — Primary key — NOT NULL
- title (Field) — not null
- create_date (Field2) — not null
user
- id (Key) — praimary — Primary key — NOT NULL
- user_id (Field5) — not null
- nick_name (Field) — not null
- password (Field2) — not null
- join_date (Field3) — null
- position (Field4) — not null