midas19th
Tables (7)
Access_Log (Untitled5)
- access_log_sn (Key) — Long — Primary key — NOT NULL
- user_sn (Key2) — Long — Foreign key → User.user_sn — NOT NULL
Banner (Untitled)
- sn (BIGINT) — Long — Primary key — NOT NULL
- contents (Field) — String
- img_url (Field2) — String
- open_yn (Field3) — Boolean
BasEntity (Untitled2)
- create_datetime (Field) — LocalDateTime
- last_modified_datetime (Field2) — LocalDateTime
- Field3
Category (Untitled7)
- category_sn (Key) — Long — Primary key — NOT NULL
- type (Field) — String
- img_url (Field2) — String
Like_User (Untitled4)
- like_user_sn (Key) — Long — Primary key — NOT NULL
- user_sn (Key2) — Long — Foreign key → User.user_sn — NOT NULL
- post_sn (Key3) — Long — Foreign key → Post.post_sn — NOT NULL
Post (Untitled6)
- post_sn (Key) — Long — Primary key — NOT NULL
- title (Field) — String
- contents (Field2) — String
- reference (Field3) — String
- description (Field4) — String
- thumbnail_url (Field5) — String
- img_url (Field6) — String
- youtube_url (Field7) — String
- category_sn (Key2) — Long — Foreign key → Category.category_sn — NOT NULL
- user_sn (Key3) — Long — Foreign key → User.user_sn — NOT NULL
User (Untitled3)
- user_sn (Key) — Long — Primary key — NOT NULL
- id (Field5) — String
- password (Field) — String
- name (Field2) — String
- dept (Field3) — String
- hire_date (Field4) — DateTime
- employee_num (Field6) — Integer
- role (Field7) — String