SDP1617-project

Tables (4)

CardImage (카드 이미지)

  • card_image_id (Key) — BIGINT — Primary key — NOT NULL
  • presinged_url (Field)
  • file_url (Field2)
  • card_id (Key2) — BIGINT — Foreign key → Cards.card_id — NOT NULL

Cards (마음 카드)

  • card_id (Key) — BIGINT — Primary key — NOT NULL
  • title (Field3) — VARCHAR(100)
  • card_design (Field) — ENUM
  • category (Field2) — ENUM
  • link (Field4) — VARCHAR(100)
  • link_title (Field5) — VARCHAR(100)
  • content (Field6) — VARCHAR(500)
  • envelop_id (Key2) — BIGNIT — Foreign key → Envelop.envelop_id — NOT NULL

Envelop (봉투)

  • envelop_id (Key) — BIGINT — Primary key — NOT NULL
  • receiver_id (Field2) — BIGINT
  • design_type (Field) — ENUM
  • sender_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL
  • receiver_id (Field3) — BIGINT

User (Untitled)

  • user_id (Key) — BIGINT — Primary key — NOT NULL
  • Field