PrePayApp

Tables (10)

ChargeRequest (충전 요청)

  • charge_request_id (요청아이디) — BIGINT — Primary key — NOT NULL
  • team_store_id (팀의가맹점아이디) — BIGINT — Foreign key → Team_Store.team_store_id — NOT NULL
  • status (상태) — VARCHAR
  • request_price (요청가격) — INT
  • request_date (일자) — BIGINT

RefundRequest (환불요청)

  • refund_request_id (요청아이디) — BIGINT — Primary key — NOT NULL
  • order_history_id (주문내역아이디) — BIGINT — Foreign key → order_history.order_history_id — NOT NULL
  • team_store_id (팀의가맹점아이디) — BIGINT — Foreign key → Team_Store.team_store_id — NOT NULL
  • user_id (유저아이디) — BIGINT — Foreign key → User.user_id — NOT NULL
  • status (상태) — VARCHAR
  • request_price (요청가격) — INT
  • request_date (일자) — BIGINT

Store (가맹점)

  • store_id (가맹점아이디) — BIGINT — Primary key — NOT NULL
  • store_name (이름) — VARCHAR
  • address (주소) — VARCHAR
  • type (업종) — VARCHAR
  • user_register_permission (유저가입허용) — TINYINT
  • longitude (식당 경도) — FLOAT
  • latitude (식당 위도) — FLOAT

Team (팀)

  • team_id (그룹아이디) — BIGINT — Primary key — NOT NULL
  • teamInitializer (유저pk) — BIGINT — Foreign key → User.user_id — NOT NULL
  • team_name (이름) — VARCHAR
  • public_team (public여부) — INT
  • team_password (그룹 비밀번호) — VARCHAR
  • daily_price_limit (일일한도) — INT
  • count_limit (주문횟수제한) — INT
  • team_message (그룹설명) — VARCHAR
  • image_url (이미지 url) — VARCHAR
  • color (색깔) — VARCHAR
  • code_gen_date (그룹 비밀번호 생성일자) — BIGINT

Team_Store (팀의 가맹점)

  • team_store_id (팀의가맹점아이디) — BIGINT — Primary key — NOT NULL
  • team_id (팀아이디) — BIGINT — Foreign key → Team.team_id — NOT NULL
  • store_id (가맹점아이디) — BIGINT — Foreign key → Store.store_id — NOT NULL
  • team_store_balance (잔액) — INT

User (유저)

  • user_id (유저pk) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR
  • user_password (비밀번호) — VARCHAR
  • nickname (닉네임) — VARCHAR

User_Team (유저의 팀)

  • user_group_id (유저의팀아이디) — BIGINT — Primary key — NOT NULL
  • team_id (팀아이디) — BIGINT — Foreign key → Team.team_id — NOT NULL
  • user_id (유저아이디) — BIGINT — Foreign key → User.user_id — NOT NULL
  • position (직책) — INT
  • privilege (회식결제권한) — INT
  • usage (사용한 금액) — INT
  • usage_count (사용횟수) — INT
  • like (좋아요) — INT

detail_history (상세내역)

  • detail_history_id (상세내역아이디) — BIGINT — Primary key — NOT NULL
  • order_history_id (주문내역아이디) — BIGINT — Foreign key → order_history.order_history_id — NOT NULL
  • product (품목) — VARCHAR
  • detail_price (상세가격) — INT
  • quantity (갯수) — INT

order_history (주문내역)

  • order_history_id (주문내역아이디) — BIGINT — Primary key — NOT NULL
  • team_id (팀아이디) — BIGINT — Foreign key → Team.team_id — NOT NULL
  • store_id (가맹점아이디) — BIGINT — Foreign key → Store.store_id — NOT NULL
  • user_id (유저아이디) — BIGINT — Foreign key → User.user_id — NOT NULL
  • order_date (일시) — BIGINT
  • total_price (금액) — INT
  • refund_status (환불상태) — INT
  • company_dinner (회식여부) — TINYINT
  • withdraw (입출금여부) — TINYINT

party_request (회식권한요청)

  • party_request_id — BIGINT — Primary key — NOT NULL
  • user_group_id (유저의그룹아이디) — BIGINT — Foreign key → User_Team.user_group_id — NOT NULL
  • request_date (요청일시) — BIGINT
  • party_request_status (상태) — VARCHAR
  • status_changed_date (상태변경일시) — BIGINT