HalPoonLee

Tables (8)

Benefit (혜택)

  • id (아이디) — Number — Primary key — NOT NULL
  • content (내용) — Varchar2
  • unit (단위) — Varchar2
  • amount (수치) — Number
  • condition (조건) — Varchar2
  • limit (한도) — Varchar2
  • brand_id (브랜드 아이디) — Number — Foreign key → Brand.id — NOT NULL
  • membership_category_id (멤버십 카테고리 아이디) — Number — Foreign key → membership_category.id — NOT NULL

Brand (브랜드)

  • id (아이디) — Number — Primary key — NOT NULL
  • name (브랜드명) — Varchar
  • business_type_id (업종아이디) — Number — Foreign key → business_type.id — NOT NULL

Member (회원)

  • id (아이디) — Number — Primary key — NOT NULL
  • login_id (로그인 아이디) — Varchar2
  • password (비밀번호) — Varchar2
  • salt_value (Salt값) — Varchar2

Store (매장)

  • id (아이디) — Number — Primary key — NOT NULL
  • name (상호명) — Varchar2
  • phone (전화번호) — Varchar2
  • latitude (위도) — Number
  • longitude (경도) — Number
  • open_hours (영업시간) — Varchar2
  • address (주소) — Varchar2
  • website (홈페이지) — Varchar2
  • brand_id (브랜드 아이디) — Number — Foreign key → Brand.id — NOT NULL

Untitled

    business_type (업종)

    • id (이이디) — Number — Primary key — NOT NULL
    • name (업종명) — Varchar2

    member_membership_category (회원 혜택 카테고리)

    • id (아이디) — Number — Primary key — NOT NULL
    • Field
    • member_id (회원 아이디) — Number — Foreign key → Member.id — NOT NULL
    • membership_category_id (멤버십 카테고리 아이디) — Number — Foreign key → membership_category.id — NOT NULL

    membership_category (멤버십 카테고리)

    • id (아이디) — Number — Primary key — NOT NULL
    • name (이름) — Varchar
    • level (레벨) — Number
    • parent_id (부모 아이디) — Number — Foreign key → membership_category.id — NOT NULL