mongsil
Tables (8)
BigCategory (대분류)
- id (Key) — Long — Primary key — NOT NULL
- name (Field) — varchar
Category (카테고리)
- id (Key) — Long — Primary key — NOT NULL
- bigCategory_id (Key2) — Long — Foreign key → BigCategory.id — NOT NULL
- name (Field) — varchar
- image (Field2) — varchar
- hit (Field3) — int
Dream (해몽)
- id (Key) — Long — Primary key — NOT NULL
- title (Field3) — varchar
- description (Field) — varchar
Dream_Card (해몽 카드)
- id (Key) — Long — Primary key — NOT NULL
- member_id (Key2) — Long — Foreign key → User.id — NOT NULL
- description (Field) — varchar
- registerDate (Field2) — date
Dream_category (해몽_카테고리)
- id (Key) — Long — Primary key — NOT NULL
- category_id (Key2) — Long — Foreign key → Category.id — NOT NULL
- dream_id (Key3) — Long — Foreign key → Dream.id — NOT NULL
User (회원)
- id (Key) — Long — Primary key — NOT NULL
- name (Field) — varchar
- email (Field2) — varchar
- pushAlarm (Field4) — boolean
- registerDate (Field3) — Date
dream_card_category (해몽 카드 카테고리)
- id (Key) — Long — Primary key — NOT NULL
- dream_card_id (Key2) — Long — Foreign key → Dream_Card.id — NOT NULL
- category_id (Key3) — Long — Foreign key → Category.id — NOT NULL
user_dream (회원이 담은 해몽)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.id — NOT NULL
- dream_id (Key3) — Long — Foreign key → Dream.id — NOT NULL
- registerDate (Key4) — date — NOT NULL