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
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