title
Tables (9)
friend
- id — INT
- owner_email — VARCHAR(100) — NOT NULL
- friend_email — VARCHAR(100) — NOT NULL
hiworksauth
- user_no — INT
- owner_email — VARCHAR(100) — NOT NULL
- office_no — INT — NOT NULL
- user_id — VARCHAR(100) — NOT NULL
- user_name — VARCHAR(100) — NOT NULL
- access_token — VARCHAR(100)
- refresh_token — VARCHAR(100)
picture
- id — INT
- owner_email — VARCHAR(100) — NOT NULL
- location — VARCHAR(100) — NOT NULL
- path — VARCHAR(100) — NOT NULL
- created_date — DATETIME — NOT NULL
- updated_date — DATETIME — NOT NULL
post
- id — INT
- owner_email — VARCHAR(100) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- contents — TEXT — NOT NULL
- parents_post_id — INT
- created_date — DATETIME — NOT NULL
- updated_date — DATETIME — NOT NULL
post_picture
- id — INT
- post_id — INT — NOT NULL
- picture_id — INT — NOT NULL
postcomment
- id — INT
- owner_email — VARCHAR(100) — NOT NULL
- post_id — INT — NOT NULL
- contents — VARCHAR(1000) — NOT NULL
- parents_comment_id — INT
- created_date — DATETIME — NOT NULL
- updated_date — DATETIME — NOT NULL
user
- email — VARCHAR(100)
- name — VARCHAR — NOT NULL
- age — INT
- birth_date — DATETIME
- password — VARCHAR(100) — NOT NULL
- is_hiworks — BOOLEAN
- created_date — DATETIME — NOT NULL
- updated_date — DATETIME — NOT NULL
usergroup
- id — INT
- owner_email — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_date — VARCHAR(100) — NOT NULL
usergroup_user
- id — INT
- usergroup_id — INT — NOT NULL
- user_email — varchar(100) — NOT NULL