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